SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}Cala{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}Cala{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}' OR prCountry = 'Cala') AND (prLocation LIKE '{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}Major{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}Major{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}' OR prCountry = 'Major') AND (prLocation LIKE '{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}Spain{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}Spain{7c9ee116dcbcf8500e5db0042bdbdfed96f297f0c620c69bf8871e89cb543c1c}' OR prCountry = 'Spain')